This section is to quickly summarize the values:
The goal is to automatically calculate the following summary statistics for the main data set provided.
Data set was for Test_Site Wind Farm
| Site.Name | WTG.Count | Manufacturer | Rating (kW) |
|---|---|---|---|
| Test_Site | 68 | GE 2.82-127 | 2820 |
| Test_Site | 5 | GE 2.52-116 | 2520 |
| DataSet_Total.Num.WTgs | DataSet_Total.WTGs.Data | WTG.Count.diff | Duplicated.WTGs |
|---|---|---|---|
| 73 | 73 | No missing WTGs | No |
CSV_Row_Count = 21096
MissingData_count BlankData_count
TimeStamp10Min 0 0
WTG 0 0
RealPower 0 0
WindSpeed 0 0
Rating 0 0
Below is a list of WTGs and their individual power rating. If there are more than one type of
WTG power rating the different rating will be shown in different colors.
| WTG | Rating (k/w) |
|---|---|
| WTG-0001 | 2520 |
| WTG-0002 | 2820 |
| WTG-0003 | 2820 |
| WTG-0004 | 2820 |
| WTG-0005 | 2820 |
| WTG-0006 | 2820 |
| WTG-0007 | 2820 |
| WTG-0008 | 2820 |
| WTG-0009 | 2820 |
| WTG-0010 | 2820 |
| WTG-0011 | 2820 |
| WTG-0012 | 2820 |
| WTG-0013 | 2820 |
| WTG-0014 | 2520 |
| WTG-0015 | 2820 |
| WTG-0016 | 2820 |
| WTG-0017 | 2820 |
| WTG-0018 | 2820 |
| WTG-0019 | 2520 |
| WTG-0020 | 2820 |
| WTG-0021 | 2820 |
| WTG-0022 | 2820 |
| WTG-0023 | 2820 |
| WTG-0024 | 2820 |
| WTG-0025 | 2820 |
| WTG-0026 | 2820 |
| WTG-0027 | 2820 |
| WTG-0028 | 2820 |
| WTG-0029 | 2820 |
| WTG-0030 | 2820 |
| WTG-0031 | 2820 |
| WTG-0032 | 2820 |
| WTG-0033 | 2820 |
| WTG-0034 | 2820 |
| WTG-0035 | 2820 |
| WTG-0036 | 2820 |
| WTG-0037 | 2820 |
| WTG-0038 | 2820 |
| WTG-0039 | 2820 |
| WTG-0040 | 2820 |
| WTG-0041 | 2820 |
| WTG-0042 | 2820 |
| WTG-0043 | 2820 |
| WTG-0044 | 2820 |
| WTG-0045 | 2820 |
| WTG-0046 | 2820 |
| WTG-0047 | 2820 |
| WTG-0048 | 2820 |
| WTG-0049 | 2820 |
| WTG-0050 | 2820 |
| WTG-0051 | 2820 |
| WTG-0052 | 2820 |
| WTG-0053 | 2820 |
| WTG-0054 | 2820 |
| WTG-0055 | 2820 |
| WTG-0056 | 2820 |
| WTG-0057 | 2820 |
| WTG-0058 | 2820 |
| WTG-0059 | 2820 |
| WTG-0060 | 2520 |
| WTG-0061 | 2820 |
| WTG-0062 | 2820 |
| WTG-0063 | 2820 |
| WTG-0064 | 2820 |
| WTG-0065 | 2820 |
| WTG-0066 | 2820 |
| WTG-0067 | 2820 |
| WTG-0068 | 2820 |
| WTG-0069 | 2820 |
| WTG-0070 | 2820 |
| WTG-0071 | 2520 |
| WTG-0072 | 2820 |
| WTG-0073 | 2820 |
Summary values below are for RealPower and WindSpeed Values for the full data set with all WTGs combined:
| RealPower | WindSpeed | |
|---|---|---|
| X | Min. : -24.471 | Min. : 0.000 |
| X.1 | 1st Qu.: -4.211 | 1st Qu.: 4.711 |
| X.2 | Median : 223.686 | Median : 6.348 |
| X.3 | Mean : 738.525 | Mean : 6.403 |
| X.4 | 3rd Qu.:1402.300 | 3rd Qu.: 8.261 |
| X.5 | Max. :2831.540 | Max. :15.930 |
TimeStamp10Min WTG RealPower WindSpeed Rating
1 2024-12-23 WTG-0001 -4.199 5.582 2520
2 2024-12-23 WTG-0001 -3.827 5.725 2520
3 2024-12-23 WTG-0001 -3.865 5.856 2520
4 2024-12-23 WTG-0001 -3.278 6.027 2520
5 2024-12-23 WTG-0001 -3.388 6.055 2520
6 2024-12-23 WTG-0001 -3.200 5.947 2520
7 2024-12-23 WTG-0001 -3.404 5.967 2520
8 2024-12-23 WTG-0001 -2.940 5.773 2520
9 2024-12-23 WTG-0001 -2.964 5.896 2520
10 2024-12-23 WTG-0001 -3.004 5.755 2520
Test for Power Production
WTG’s that FAIL a test below will be highlighted RED if one or both of these conditions are not achieved:
Notification of possible issues
WTG’s will be highlighted Orange if these conditions are meet. This is still considered a PASS, but will be a Notification:
DateStart = 2024-12-23 00:00 / DateEnd = 2024-12-25 00:00
| WTG | Rating (k/w) | MaxPower (k/w) | 98% of Rated | TotalProduction (k/w) | ReachRated_hrs | 3Days_Production_hrs | LastDayProduction_hrs |
|---|---|---|---|---|---|---|---|
| WTG-0001 | 2520 | 743.12 | 29.49% | 6477.98 | 0 | 12.33 | 6 |
| WTG-0002 | 2820 | 1828.88 | 64.85% | 16106.46 | 0 | 21.83 | 10 |
| WTG-0003 | 2820 | 2830.73 | 100.38% | 49806.53 | 4.5 | 31.33 | 19.83 |
| WTG-0004 | 2820 | 2831.38 | 100.4% | 43364.08 | 3 | 30.83 | 19 |
| WTG-0005 | 2820 | 2830.42 | 100.37% | 56658.76 | 4.5 | 31.5 | 20 |
| WTG-0006 | 2820 | 2219.25 | 78.7% | 14062.91 | 0 | 9.17 | 3 |
| WTG-0007 | 2820 | -2.81 | 0% | -212.14 | 0 | 0 | 0 |
| WTG-0008 | 2820 | 1917.92 | 68.01% | 770.67 | 0 | 0.83 | 0 |
| WTG-0009 | 2820 | 2831.05 | 100.39% | 53958.80 | 4.67 | 31.5 | 19.67 |
| WTG-0010 | 2820 | 2830.69 | 100.38% | 54824.20 | 5.67 | 31.5 | 19.67 |
| WTG-0011 | 2820 | 1386.31 | 49.16% | 1397.51 | 0 | 2 | 0 |
| WTG-0012 | 2820 | 2830.35 | 100.37% | 33123.07 | 0.83 | 29.67 | 19.67 |
| WTG-0013 | 2820 | 2830.47 | 100.37% | 45525.31 | 2.83 | 29.67 | 19.5 |
| WTG-0014 | 2520 | 2529.95 | 100.39% | 23735.19 | 0.5 | 27.67 | 16.33 |
| WTG-0015 | 2820 | 2830.96 | 100.39% | 46643.99 | 3.5 | 30.83 | 19.5 |
| WTG-0016 | 2820 | -3.06 | 0% | -203.03 | 0 | 0 | 0 |
| WTG-0017 | 2820 | 2830.52 | 100.37% | 37739.30 | 2.17 | 31.17 | 19.33 |
| WTG-0018 | 2820 | 2029.78 | 71.98% | 1648.87 | 0 | 1.67 | 0 |
| WTG-0019 | 2520 | 1327.57 | 52.68% | 14584.82 | 0 | 22.83 | 11.17 |
| WTG-0020 | 2820 | 2830.77 | 100.38% | 51958.46 | 3.67 | 33.17 | 21.33 |
| WTG-0021 | 2820 | 2830.71 | 100.38% | 61238.87 | 3.83 | 32.83 | 21.5 |
| WTG-0022 | 2820 | 2830.61 | 100.38% | 56090.69 | 3.33 | 33.17 | 21.33 |
| WTG-0023 | 2820 | 2830.45 | 100.37% | 56324.20 | 4.83 | 30.33 | 20 |
| WTG-0024 | 2820 | 2830.51 | 100.37% | 49403.87 | 4.17 | 32 | 20.17 |
| WTG-0025 | 2820 | 2725.56 | 96.65% | 51159.09 | 0 | 31.67 | 20.83 |
| WTG-0026 | 2820 | 2086.68 | 74% | 7904.29 | 0 | 8.5 | 0 |
| WTG-0027 | 2820 | 2830.95 | 100.39% | 58200.97 | 5.67 | 31.83 | 20.5 |
| WTG-0028 | 2820 | 2831.47 | 100.41% | 52482.13 | 3.67 | 32.33 | 20.67 |
| WTG-0029 | 2820 | 67.27 | 2.39% | -239.92 | 0 | 0 | 0 |
| WTG-0030 | 2820 | 2235.46 | 79.27% | 47845.79 | 0 | 31.17 | 20.5 |
| WTG-0031 | 2820 | 2830.68 | 100.38% | 58181.36 | 4.67 | 32 | 20.33 |
| WTG-0032 | 2820 | 2830.32 | 100.37% | 52058.69 | 3.83 | 32 | 20.67 |
| WTG-0033 | 2820 | 2830.96 | 100.39% | 50302.13 | 4.17 | 31.83 | 20.67 |
| WTG-0034 | 2820 | 2830.82 | 100.38% | 53035.10 | 4.33 | 31.33 | 20.17 |
| WTG-0035 | 2820 | 533.07 | 18.9% | 452.46 | 0 | 1.17 | 0 |
| WTG-0036 | 2820 | 190.8 | 6.77% | -183.07 | 0 | 0 | 0 |
| WTG-0037 | 2820 | 2830.81 | 100.38% | 50545.72 | 5 | 32.83 | 21.67 |
| WTG-0038 | 2820 | -3.05 | 0% | -237.84 | 0 | 0 | 0 |
| WTG-0039 | 2820 | 1806.39 | 64.06% | 37425.98 | 0 | 32.17 | 21 |
| WTG-0040 | 2820 | 2830.2 | 100.36% | 46461.35 | 2.83 | 32.17 | 21 |
| WTG-0041 | 2820 | 1910.86 | 67.76% | 1257.48 | 0 | 1.17 | 0 |
| WTG-0042 | 2820 | 2237.23 | 79.33% | 44187.20 | 0 | 32.5 | 20.83 |
| WTG-0043 | 2820 | 2237.54 | 79.35% | 45317.11 | 0 | 33.17 | 21.5 |
| WTG-0044 | 2820 | 2831.52 | 100.41% | 56745.03 | 3.83 | 32 | 20.83 |
| WTG-0045 | 2820 | 2830.87 | 100.39% | 59077.73 | 5.17 | 31.67 | 21.67 |
| WTG-0046 | 2820 | 2725.37 | 96.64% | 51435.23 | 0 | 32.83 | 21.17 |
| WTG-0047 | 2820 | 2237.89 | 79.36% | 35375.04 | 0 | 31.17 | 20.33 |
| WTG-0048 | 2820 | 2003.03 | 71.03% | 21369.28 | 0 | 21.83 | 10.33 |
| WTG-0049 | 2820 | 2830.67 | 100.38% | 41555.54 | 3.17 | 31.67 | 20 |
| WTG-0050 | 2820 | 1699.85 | 60.28% | 33448.44 | 0 | 29.33 | 19.33 |
| WTG-0051 | 2820 | 2830.93 | 100.39% | 50630.74 | 3.83 | 31.5 | 20.17 |
| WTG-0052 | 2820 | 2725.46 | 96.65% | 52526.99 | 0 | 33 | 21.33 |
| WTG-0053 | 2820 | 2725.69 | 96.66% | 52635.04 | 0 | 32.67 | 21.33 |
| WTG-0054 | 2820 | 2830.41 | 100.37% | 55411.55 | 4.17 | 31.67 | 20.5 |
| WTG-0055 | 2820 | 2504.88 | 88.83% | 34965.90 | 0 | 20.17 | 13.17 |
| WTG-0056 | 2820 | 716.2 | 25.4% | 391.20 | 0 | 1 | 0 |
| WTG-0057 | 2820 | 200.6 | 7.11% | 6452.88 | 0 | 0 | 0 |
| WTG-0058 | 2820 | 1903.5 | 67.5% | 43592.31 | 0 | 31.67 | 21.5 |
| WTG-0059 | 2820 | 2830.99 | 100.39% | 47982.13 | 3.17 | 31.33 | 20.5 |
| WTG-0060 | 2520 | 2530.5 | 100.42% | 31459.50 | 3.33 | 28.17 | 20.33 |
| WTG-0061 | 2820 | 2831.26 | 100.4% | 62047.80 | 7.17 | 29.33 | 21.83 |
| WTG-0062 | 2820 | 2831.54 | 100.41% | 57741.94 | 4.33 | 33 | 21.67 |
| WTG-0063 | 2820 | 2830.4 | 100.37% | 35359.89 | 4.17 | 23.67 | 16 |
| WTG-0064 | 2820 | 2830.42 | 100.37% | 59508.01 | 5.33 | 31 | 20.67 |
| WTG-0065 | 2820 | 2830.5 | 100.37% | 32992.73 | 2.83 | 31 | 20.5 |
| WTG-0066 | 2820 | 2830.76 | 100.38% | 49003.79 | 5.33 | 28.83 | 21.5 |
| WTG-0067 | 2820 | 886.89 | 31.45% | 3812.40 | 0 | 8.67 | 0 |
| WTG-0068 | 2820 | 2830.86 | 100.39% | 62817.12 | 3 | 33.5 | 22.17 |
| WTG-0069 | 2820 | 2205.88 | 78.22% | 13901.77 | 0 | 10.67 | 4.83 |
| WTG-0070 | 2820 | 2182.93 | 77.41% | 7340.42 | 0 | 7.5 | 1.17 |
| WTG-0071 | 2520 | 2531.53 | 100.46% | 25515.14 | 1.33 | 26.5 | 19 |
| WTG-0072 | 2820 | 2830.08 | 100.36% | 33513.09 | 1.5 | 28.33 | 21 |
| WTG-0073 | 2820 | 2830.93 | 100.39% | 46860.02 | 4.83 | 30.17 | 19.5 |
Find all WTGS that will not have enough or correct data to process Power Values.
[1] "WTG - WTG-0001 - WTG did NOT reach rated power."
[1] "WTG - WTG-0019 - WTG did NOT reach rated power."
[1] "WTG - WTG-0002 - WTG did NOT reach rated power."
[1] "WTG - WTG-0006 - WTG did NOT reach rated power."
[1] "WTG - WTG-0007 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0008 - WTG did NOT reach rated power."
[1] "WTG - WTG-0011 - WTG did NOT reach rated power."
[1] "WTG - WTG-0016 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0018 - WTG did NOT reach rated power."
[1] "WTG - WTG-0025 - WTG did NOT reach rated power."
[1] "WTG - WTG-0026 - WTG did NOT reach rated power."
[1] "WTG - WTG-0029 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0030 - WTG did NOT reach rated power."
[1] "WTG - WTG-0035 - WTG did NOT reach rated power."
[1] "WTG - WTG-0036 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0038 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0039 - WTG did NOT reach rated power."
[1] "WTG - WTG-0041 - WTG did NOT reach rated power."
[1] "WTG - WTG-0042 - WTG did NOT reach rated power."
[1] "WTG - WTG-0043 - WTG did NOT reach rated power."
[1] "WTG - WTG-0046 - WTG did NOT reach rated power."
[1] "WTG - WTG-0047 - WTG did NOT reach rated power."
[1] "WTG - WTG-0048 - WTG did NOT reach rated power."
[1] "WTG - WTG-0050 - WTG did NOT reach rated power."
[1] "WTG - WTG-0052 - WTG did NOT reach rated power."
[1] "WTG - WTG-0053 - WTG did NOT reach rated power."
[1] "WTG - WTG-0055 - WTG did NOT reach rated power."
[1] "WTG - WTG-0056 - WTG did NOT reach rated power."
[1] "WTG - WTG-0057 - WTG did NOT reach rated power."
[1] "WTG - WTG-0058 - WTG did NOT reach rated power."
[1] "WTG - WTG-0067 - WTG did NOT reach rated power."
[1] "WTG - WTG-0069 - WTG did NOT reach rated power."
[1] "WTG - WTG-0070 - WTG did NOT reach rated power."